Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 28080 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.8 MiB |
| Average record size in memory | 104.0 B |
Variable types
| Numeric | 7 |
|---|---|
| Categorical | 4 |
| Text | 2 |
periodo is uniformly distributed | Uniform |
plan_precios_cuidados has 27842 (99.2%) zeros | Zeros |
cust_request_qty has 5731 (20.4%) zeros | Zeros |
cust_request_tn has 5731 (20.4%) zeros | Zeros |
tn has 5731 (20.4%) zeros | Zeros |
Reproduction
| Analysis started | 2024-07-13 12:45:13.949006 |
|---|---|
| Analysis finished | 2024-07-13 12:45:19.652266 |
| Duration | 5.7 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
product_id
Real number (ℝ)
| Distinct | 780 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20541.422 |
| Minimum | 20001 |
|---|---|
| Maximum | 21276 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 219.5 KiB |
Quantile statistics
| Minimum | 20001 |
|---|---|
| 5-th percentile | 20042.95 |
| Q1 | 20238.75 |
| median | 20511.5 |
| Q3 | 20818.5 |
| 95-th percentile | 21167.05 |
| Maximum | 21276 |
| Range | 1275 |
| Interquartile range (IQR) | 579.75 |
Descriptive statistics
| Standard deviation | 353.76366 |
|---|---|
| Coefficient of variation (CV) | 0.017221965 |
| Kurtosis | -1.0230288 |
| Mean | 20541.422 |
| Median Absolute Deviation (MAD) | 286 |
| Skewness | 0.29765975 |
| Sum | 5.7680312 × 108 |
| Variance | 125148.72 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20001 | 36 | 0.1% |
| 20202 | 36 | 0.1% |
| 20343 | 36 | 0.1% |
| 20377 | 36 | 0.1% |
| 20417 | 36 | 0.1% |
| 20750 | 36 | 0.1% |
| 20832 | 36 | 0.1% |
| 20855 | 36 | 0.1% |
| 20877 | 36 | 0.1% |
| 20914 | 36 | 0.1% |
| Other values (770) | 27720 |
| Value | Count | Frequency (%) |
| 20001 | 36 | |
| 20002 | 36 | |
| 20003 | 36 | |
| 20004 | 36 | |
| 20005 | 36 | |
| 20006 | 36 | |
| 20007 | 36 | |
| 20008 | 36 | |
| 20009 | 36 | |
| 20010 | 36 |
| Value | Count | Frequency (%) |
| 21276 | 36 | |
| 21267 | 36 | |
| 21266 | 36 | |
| 21265 | 36 | |
| 21263 | 36 | |
| 21262 | 36 | |
| 21259 | 36 | |
| 21256 | 36 | |
| 21252 | 36 | |
| 21248 | 36 |
periodo
Categorical
UNIFORM 
| Distinct | 36 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 219.5 KiB |
| 2017-01-01 | 780 |
|---|---|
| 2017-02-01 | 780 |
| 2017-09-01 | 780 |
| 2017-03-01 | 780 |
| 2017-04-01 | 780 |
| Other values (31) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 280800 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2017-01-01 |
|---|---|
| 2nd row | 2017-02-01 |
| 3rd row | 2017-03-01 |
| 4th row | 2017-04-01 |
| 5th row | 2017-05-01 |
Common Values
| Value | Count | Frequency (%) |
| 2017-01-01 | 780 | 2.8% |
| 2017-02-01 | 780 | 2.8% |
| 2017-09-01 | 780 | 2.8% |
| 2017-03-01 | 780 | 2.8% |
| 2017-04-01 | 780 | 2.8% |
| 2017-05-01 | 780 | 2.8% |
| 2017-06-01 | 780 | 2.8% |
| 2017-07-01 | 780 | 2.8% |
| 2017-08-01 | 780 | 2.8% |
| 2017-10-01 | 780 | 2.8% |
| Other values (26) | 20280 |
Length
| Value | Count | Frequency (%) |
| 2017-01-01 | 780 | 2.8% |
| 2017-02-01 | 780 | 2.8% |
| 2019-03-01 | 780 | 2.8% |
| 2018-09-01 | 780 | 2.8% |
| 2018-10-01 | 780 | 2.8% |
| 2018-11-01 | 780 | 2.8% |
| 2018-12-01 | 780 | 2.8% |
| 2019-01-01 | 780 | 2.8% |
| 2019-02-01 | 780 | 2.8% |
| 2019-04-01 | 780 | 2.8% |
| Other values (26) | 20280 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 79560 | |
| 1 | 67860 | |
| - | 56160 | |
| 2 | 32760 | |
| 7 | 11700 | 4.2% |
| 9 | 11700 | 4.2% |
| 8 | 11700 | 4.2% |
| 3 | 2340 | 0.8% |
| 4 | 2340 | 0.8% |
| 5 | 2340 | 0.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 280800 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 79560 | |
| 1 | 67860 | |
| - | 56160 | |
| 2 | 32760 | |
| 7 | 11700 | 4.2% |
| 9 | 11700 | 4.2% |
| 8 | 11700 | 4.2% |
| 3 | 2340 | 0.8% |
| 4 | 2340 | 0.8% |
| 5 | 2340 | 0.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 280800 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 79560 | |
| 1 | 67860 | |
| - | 56160 | |
| 2 | 32760 | |
| 7 | 11700 | 4.2% |
| 9 | 11700 | 4.2% |
| 8 | 11700 | 4.2% |
| 3 | 2340 | 0.8% |
| 4 | 2340 | 0.8% |
| 5 | 2340 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 280800 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 79560 | |
| 1 | 67860 | |
| - | 56160 | |
| 2 | 32760 | |
| 7 | 11700 | 4.2% |
| 9 | 11700 | 4.2% |
| 8 | 11700 | 4.2% |
| 3 | 2340 | 0.8% |
| 4 | 2340 | 0.8% |
| 5 | 2340 | 0.8% |
plan_precios_cuidados
Real number (ℝ)
ZEROS 
| Distinct | 135 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.99465812 |
| Minimum | 0 |
|---|---|
| Maximum | 289 |
| Zeros | 27842 |
| Zeros (%) | 99.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 219.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 289 |
| Range | 289 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 11.59233 |
|---|---|
| Coefficient of variation (CV) | 11.654587 |
| Kurtosis | 180.31647 |
| Mean | 0.99465812 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 12.908125 |
| Sum | 27930 |
| Variance | 134.38211 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 27842 | |
| 93 | 6 | < 0.1% |
| 159 | 5 | < 0.1% |
| 87 | 5 | < 0.1% |
| 110 | 4 | < 0.1% |
| 65 | 4 | < 0.1% |
| 129 | 4 | < 0.1% |
| 63 | 4 | < 0.1% |
| 144 | 4 | < 0.1% |
| 123 | 4 | < 0.1% |
| Other values (125) | 198 | 0.7% |
| Value | Count | Frequency (%) |
| 0 | 27842 | |
| 9 | 1 | < 0.1% |
| 22 | 1 | < 0.1% |
| 25 | 1 | < 0.1% |
| 29 | 1 | < 0.1% |
| 30 | 1 | < 0.1% |
| 32 | 2 | < 0.1% |
| 37 | 1 | < 0.1% |
| 42 | 1 | < 0.1% |
| 44 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 289 | 1 | |
| 274 | 1 | |
| 218 | 1 | |
| 217 | 1 | |
| 213 | 1 | |
| 207 | 1 | |
| 205 | 1 | |
| 200 | 1 | |
| 199 | 1 | |
| 192 | 1 |
cust_request_qty
Real number (ℝ)
ZEROS 
| Distinct | 652 |
|---|---|
| Distinct (%) | 2.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 177.30345 |
| Minimum | 0 |
|---|---|
| Maximum | 756 |
| Zeros | 5731 |
| Zeros (%) | 20.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 219.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 50 |
| median | 167 |
| Q3 | 275 |
| 95-th percentile | 433 |
| Maximum | 756 |
| Range | 756 |
| Interquartile range (IQR) | 225 |
Descriptive statistics
| Standard deviation | 142.31954 |
|---|---|
| Coefficient of variation (CV) | 0.80268906 |
| Kurtosis | -0.42606118 |
| Mean | 177.30345 |
| Median Absolute Deviation (MAD) | 112 |
| Skewness | 0.49717329 |
| Sum | 4978681 |
| Variance | 20254.852 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5731 | 20.4% |
| 151 | 99 | 0.4% |
| 126 | 91 | 0.3% |
| 210 | 91 | 0.3% |
| 168 | 89 | 0.3% |
| 184 | 88 | 0.3% |
| 147 | 88 | 0.3% |
| 124 | 88 | 0.3% |
| 208 | 87 | 0.3% |
| 140 | 87 | 0.3% |
| Other values (642) | 21541 |
| Value | Count | Frequency (%) |
| 0 | 5731 | |
| 1 | 25 | 0.1% |
| 2 | 19 | 0.1% |
| 3 | 16 | 0.1% |
| 4 | 20 | 0.1% |
| 5 | 42 | 0.1% |
| 6 | 26 | 0.1% |
| 7 | 33 | 0.1% |
| 8 | 25 | 0.1% |
| 9 | 20 | 0.1% |
| Value | Count | Frequency (%) |
| 756 | 1 | |
| 736 | 1 | |
| 725 | 1 | |
| 721 | 1 | |
| 718 | 1 | |
| 704 | 1 | |
| 701 | 1 | |
| 696 | 2 | |
| 695 | 1 | |
| 691 | 1 |
cust_request_tn
Real number (ℝ)
ZEROS 
| Distinct | 22141 |
|---|---|
| Distinct (%) | 78.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.880852 |
| Minimum | 0 |
|---|---|
| Maximum | 2423.7088 |
| Zeros | 5731 |
| Zeros (%) | 20.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 219.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.459455 |
| median | 6.22387 |
| Q3 | 25.083377 |
| 95-th percentile | 190.09327 |
| Maximum | 2423.7088 |
| Range | 2423.7088 |
| Interquartile range (IQR) | 24.623922 |
Descriptive statistics
| Standard deviation | 117.3055 |
|---|---|
| Coefficient of variation (CV) | 2.8694486 |
| Kurtosis | 67.527369 |
| Mean | 40.880852 |
| Median Absolute Deviation (MAD) | 6.22387 |
| Skewness | 6.8592699 |
| Sum | 1147934.3 |
| Variance | 13760.581 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5731 | 20.4% |
| 0.00988 | 5 | < 0.1% |
| 0.00874 | 4 | < 0.1% |
| 0.0127 | 3 | < 0.1% |
| 6.3063 | 3 | < 0.1% |
| 66.41271 | 3 | < 0.1% |
| 0.48948 | 3 | < 0.1% |
| 1.51788 | 3 | < 0.1% |
| 0.01128 | 3 | < 0.1% |
| 0.02682 | 3 | < 0.1% |
| Other values (22131) | 22319 |
| Value | Count | Frequency (%) |
| 0 | 5731 | |
| 0.00089 | 1 | < 0.1% |
| 0.00092 | 1 | < 0.1% |
| 0.00218 | 1 | < 0.1% |
| 0.00223 | 1 | < 0.1% |
| 0.00268 | 1 | < 0.1% |
| 0.00294 | 1 | < 0.1% |
| 0.00295 | 1 | < 0.1% |
| 0.00301 | 1 | < 0.1% |
| 0.00311 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2423.70881 | 1 | |
| 2013.36305 | 1 | |
| 2010.29987 | 1 | |
| 1945.84961 | 1 | |
| 1902.79056 | 1 | |
| 1859.88471 | 1 | |
| 1823.35962 | 1 | |
| 1782.81423 | 1 | |
| 1757.73271 | 1 | |
| 1734.24194 | 1 |
tn
Real number (ℝ)
ZEROS 
| Distinct | 22146 |
|---|---|
| Distinct (%) | 78.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 39.978818 |
| Minimum | 0 |
|---|---|
| Maximum | 2295.1983 |
| Zeros | 5731 |
| Zeros (%) | 20.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 219.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.459985 |
| median | 6.1997 |
| Q3 | 24.879885 |
| 95-th percentile | 186.68862 |
| Maximum | 2295.1983 |
| Range | 2295.1983 |
| Interquartile range (IQR) | 24.4199 |
Descriptive statistics
| Standard deviation | 113.35357 |
|---|---|
| Coefficient of variation (CV) | 2.8353406 |
| Kurtosis | 65.75445 |
| Mean | 39.978818 |
| Median Absolute Deviation (MAD) | 6.1997 |
| Skewness | 6.7677241 |
| Sum | 1122605.2 |
| Variance | 12849.031 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5731 | 20.4% |
| 0.00988 | 5 | < 0.1% |
| 0.00874 | 4 | < 0.1% |
| 0.0127 | 3 | < 0.1% |
| 0.01128 | 3 | < 0.1% |
| 0.02682 | 3 | < 0.1% |
| 1.51788 | 3 | < 0.1% |
| 0.48948 | 3 | < 0.1% |
| 2.02891 | 3 | < 0.1% |
| 6.3063 | 3 | < 0.1% |
| Other values (22136) | 22319 |
| Value | Count | Frequency (%) |
| 0 | 5731 | |
| 0.00089 | 1 | < 0.1% |
| 0.00092 | 1 | < 0.1% |
| 0.00218 | 1 | < 0.1% |
| 0.00223 | 1 | < 0.1% |
| 0.00268 | 1 | < 0.1% |
| 0.00294 | 1 | < 0.1% |
| 0.00295 | 1 | < 0.1% |
| 0.00301 | 1 | < 0.1% |
| 0.00311 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2295.19832 | 1 | |
| 1979.53635 | 1 | |
| 1958.59845 | 1 | |
| 1856.83534 | 1 | |
| 1813.01511 | 1 | |
| 1800.96168 | 1 | |
| 1766.81068 | 1 | |
| 1678.99318 | 1 | |
| 1660.00561 | 1 | |
| 1647.63848 | 1 |
cant_periodos
Real number (ℝ)
| Distinct | 29 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.652564 |
| Minimum | 4 |
|---|---|
| Maximum | 36 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 219.5 KiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 21 |
| median | 36 |
| Q3 | 36 |
| 95-th percentile | 36 |
| Maximum | 36 |
| Range | 32 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 11.038524 |
|---|---|
| Coefficient of variation (CV) | 0.38525432 |
| Kurtosis | -0.43680349 |
| Mean | 28.652564 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -1.1107161 |
| Sum | 804564 |
| Variance | 121.84901 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 36 | 17208 | |
| 9 | 1080 | 3.8% |
| 6 | 792 | 2.8% |
| 15 | 684 | 2.4% |
| 16 | 684 | 2.4% |
| 35 | 612 | 2.2% |
| 7 | 576 | 2.1% |
| 5 | 540 | 1.9% |
| 10 | 540 | 1.9% |
| 26 | 540 | 1.9% |
| Other values (19) | 4824 | 17.2% |
| Value | Count | Frequency (%) |
| 4 | 324 | 1.2% |
| 5 | 540 | |
| 6 | 792 | |
| 7 | 576 | |
| 8 | 468 | |
| 9 | 1080 | |
| 10 | 540 | |
| 11 | 144 | 0.5% |
| 14 | 360 | 1.3% |
| 15 | 684 |
| Value | Count | Frequency (%) |
| 36 | 17208 | |
| 35 | 612 | 2.2% |
| 34 | 180 | 0.6% |
| 33 | 72 | 0.3% |
| 32 | 144 | 0.5% |
| 31 | 252 | 0.9% |
| 30 | 432 | 1.5% |
| 29 | 180 | 0.6% |
| 28 | 216 | 0.8% |
| 27 | 468 | 1.7% |
cat1
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 219.5 KiB |
| PC | |
|---|---|
| HC | |
| FOODS | |
| REF | 216 |
Length
| Max length | 5 |
|---|---|
| Median length | 2 |
| Mean length | 2.5576923 |
| Min length | 2 |
Characters and Unicode
| Total characters | 71820 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | HC |
|---|---|
| 2nd row | HC |
| 3rd row | HC |
| 4th row | HC |
| 5th row | HC |
Common Values
| Value | Count | Frequency (%) |
| PC | 15984 | |
| HC | 6732 | |
| FOODS | 5148 | 18.3% |
| REF | 216 | 0.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| pc | 15984 | |
| hc | 6732 | |
| foods | 5148 | 18.3% |
| ref | 216 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 22716 | |
| P | 15984 | |
| O | 10296 | |
| H | 6732 | 9.4% |
| F | 5364 | 7.5% |
| D | 5148 | 7.2% |
| S | 5148 | 7.2% |
| R | 216 | 0.3% |
| E | 216 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 71820 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| C | 22716 | |
| P | 15984 | |
| O | 10296 | |
| H | 6732 | 9.4% |
| F | 5364 | 7.5% |
| D | 5148 | 7.2% |
| S | 5148 | 7.2% |
| R | 216 | 0.3% |
| E | 216 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 71820 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| C | 22716 | |
| P | 15984 | |
| O | 10296 | |
| H | 6732 | 9.4% |
| F | 5364 | 7.5% |
| D | 5148 | 7.2% |
| S | 5148 | 7.2% |
| R | 216 | 0.3% |
| E | 216 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 71820 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| C | 22716 | |
| P | 15984 | |
| O | 10296 | |
| H | 6732 | 9.4% |
| F | 5364 | 7.5% |
| D | 5148 | 7.2% |
| S | 5148 | 7.2% |
| R | 216 | 0.3% |
| E | 216 | 0.3% |
cat2
Categorical
| Distinct | 15 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 219.5 KiB |
| CABELLO | |
|---|---|
| DEOS | |
| SOPAS Y CALDOS | |
| HOGAR | |
| PIEL2 | |
| Other values (10) |
Length
| Max length | 19 |
|---|---|
| Median length | 14 |
| Mean length | 7.5294872 |
| Min length | 2 |
Characters and Unicode
| Total characters | 211428 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ROPA LAVADO |
|---|---|
| 2nd row | ROPA LAVADO |
| 3rd row | ROPA LAVADO |
| 4th row | ROPA LAVADO |
| 5th row | ROPA LAVADO |
Common Values
| Value | Count | Frequency (%) |
| CABELLO | 7308 | |
| DEOS | 4428 | |
| SOPAS Y CALDOS | 3060 | |
| HOGAR | 2268 | 8.1% |
| PIEL2 | 2052 | 7.3% |
| ROPA LAVADO | 1908 | 6.8% |
| ADEREZOS | 1764 | 6.3% |
| PIEL1 | 1692 | 6.0% |
| VAJILLA | 1188 | 4.2% |
| ROPA ACONDICIONADOR | 756 | 2.7% |
| Other values (5) | 1656 | 5.9% |
Length
| Value | Count | Frequency (%) |
| cabello | 7308 | |
| deos | 4428 | |
| sopas | 3060 | |
| y | 3060 | |
| caldos | 3060 | |
| ropa | 2736 | 7.4% |
| hogar | 2268 | 6.1% |
| piel2 | 2052 | 5.6% |
| lavado | 1908 | 5.2% |
| aderezos | 1764 | 4.8% |
| Other values (8) | 5292 |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 30528 | |
| A | 29088 | |
| L | 26748 | |
| E | 20268 | |
| S | 16308 | |
| D | 13176 | 6.2% |
| C | 11952 | 5.7% |
| P | 10080 | 4.8% |
| 8856 | 4.2% | |
| R | 8388 | 4.0% |
| Other values (14) | 36036 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 211428 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| O | 30528 | |
| A | 29088 | |
| L | 26748 | |
| E | 20268 | |
| S | 16308 | |
| D | 13176 | 6.2% |
| C | 11952 | 5.7% |
| P | 10080 | 4.8% |
| 8856 | 4.2% | |
| R | 8388 | 4.0% |
| Other values (14) | 36036 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 211428 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| O | 30528 | |
| A | 29088 | |
| L | 26748 | |
| E | 20268 | |
| S | 16308 | |
| D | 13176 | 6.2% |
| C | 11952 | 5.7% |
| P | 10080 | 4.8% |
| 8856 | 4.2% | |
| R | 8388 | 4.0% |
| Other values (14) | 36036 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 211428 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| O | 30528 | |
| A | 29088 | |
| L | 26748 | |
| E | 20268 | |
| S | 16308 | |
| D | 13176 | 6.2% |
| C | 11952 | 5.7% |
| P | 10080 | 4.8% |
| 8856 | 4.2% | |
| R | 8388 | 4.0% |
| Other values (14) | 36036 |
cat3
Text
| Distinct | 84 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 219.5 KiB |
Length
| Max length | 19 |
|---|---|
| Median length | 16 |
| Mean length | 7.9589744 |
| Min length | 3 |
Characters and Unicode
| Total characters | 223488 |
|---|---|
| Distinct characters | 51 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Liquido |
|---|---|
| 2nd row | Liquido |
| 3rd row | Liquido |
| 4th row | Liquido |
| 5th row | Liquido |
| Value | Count | Frequency (%) |
| shampoo | 3276 | 9.9% |
| aero | 2808 | 8.5% |
| acondicionador | 2772 | 8.4% |
| jabon | 1368 | 4.1% |
| liquido | 1224 | 3.7% |
| sopas | 1152 | 3.5% |
| mayonesa | 936 | 2.8% |
| polvo | 900 | 2.7% |
| noaero | 828 | 2.5% |
| gel | 792 | 2.4% |
| Other values (80) | 17028 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 19260 | 8.6% |
| O | 16920 | 7.6% |
| a | 15948 | 7.1% |
| A | 15624 | 7.0% |
| e | 11340 | 5.1% |
| C | 10152 | 4.5% |
| r | 9936 | 4.4% |
| S | 7596 | 3.4% |
| i | 7488 | 3.4% |
| I | 7452 | 3.3% |
| Other values (41) | 101772 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 223488 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 19260 | 8.6% |
| O | 16920 | 7.6% |
| a | 15948 | 7.1% |
| A | 15624 | 7.0% |
| e | 11340 | 5.1% |
| C | 10152 | 4.5% |
| r | 9936 | 4.4% |
| S | 7596 | 3.4% |
| i | 7488 | 3.4% |
| I | 7452 | 3.3% |
| Other values (41) | 101772 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 223488 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 19260 | 8.6% |
| O | 16920 | 7.6% |
| a | 15948 | 7.1% |
| A | 15624 | 7.0% |
| e | 11340 | 5.1% |
| C | 10152 | 4.5% |
| r | 9936 | 4.4% |
| S | 7596 | 3.4% |
| i | 7488 | 3.4% |
| I | 7452 | 3.3% |
| Other values (41) | 101772 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 223488 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 19260 | 8.6% |
| O | 16920 | 7.6% |
| a | 15948 | 7.1% |
| A | 15624 | 7.0% |
| e | 11340 | 5.1% |
| C | 10152 | 4.5% |
| r | 9936 | 4.4% |
| S | 7596 | 3.4% |
| i | 7488 | 3.4% |
| I | 7452 | 3.3% |
| Other values (41) | 101772 |
brand
Categorical
| Distinct | 35 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 219.5 KiB |
| NIVEA | |
|---|---|
| SHAMPOO3 | |
| MAGGI | |
| DEOS1 | |
| MUSCULO | |
| Other values (30) |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 6.3038462 |
| Min length | 3 |
Characters and Unicode
| Total characters | 177012 |
|---|---|
| Distinct characters | 35 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ARIEL |
|---|---|
| 2nd row | ARIEL |
| 3rd row | ARIEL |
| 4th row | ARIEL |
| 5th row | ARIEL |
Common Values
| Value | Count | Frequency (%) |
| NIVEA | 3924 | |
| SHAMPOO3 | 2952 | 10.5% |
| MAGGI | 2808 | 10.0% |
| DEOS1 | 2808 | 10.0% |
| MUSCULO | 2340 | 8.3% |
| LIMPIEX | 1620 | 5.8% |
| LANCOME | 1080 | 3.8% |
| SHAMPOO2 | 1044 | 3.7% |
| NATURA | 1008 | 3.6% |
| SHAMPOO1 | 972 | 3.5% |
| Other values (25) | 7524 |
Length
| Value | Count | Frequency (%) |
| nivea | 3924 | |
| shampoo3 | 2952 | 10.5% |
| maggi | 2808 | 10.0% |
| deos1 | 2808 | 10.0% |
| musculo | 2340 | 8.3% |
| limpiex | 1620 | 5.8% |
| lancome | 1080 | 3.8% |
| shampoo2 | 1044 | 3.7% |
| natura | 1008 | 3.6% |
| shampoo1 | 972 | 3.5% |
| Other values (25) | 7524 |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 20268 | 11.5% |
| A | 20124 | 11.4% |
| M | 14184 | 8.0% |
| I | 13896 | 7.9% |
| E | 13608 | 7.7% |
| S | 12672 | 7.2% |
| N | 8244 | 4.7% |
| P | 7884 | 4.5% |
| L | 7524 | 4.3% |
| G | 6804 | 3.8% |
| Other values (25) | 51804 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 177012 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| O | 20268 | 11.5% |
| A | 20124 | 11.4% |
| M | 14184 | 8.0% |
| I | 13896 | 7.9% |
| E | 13608 | 7.7% |
| S | 12672 | 7.2% |
| N | 8244 | 4.7% |
| P | 7884 | 4.5% |
| L | 7524 | 4.3% |
| G | 6804 | 3.8% |
| Other values (25) | 51804 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 177012 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| O | 20268 | 11.5% |
| A | 20124 | 11.4% |
| M | 14184 | 8.0% |
| I | 13896 | 7.9% |
| E | 13608 | 7.7% |
| S | 12672 | 7.2% |
| N | 8244 | 4.7% |
| P | 7884 | 4.5% |
| L | 7524 | 4.3% |
| G | 6804 | 3.8% |
| Other values (25) | 51804 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 177012 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| O | 20268 | 11.5% |
| A | 20124 | 11.4% |
| M | 14184 | 8.0% |
| I | 13896 | 7.9% |
| E | 13608 | 7.7% |
| S | 12672 | 7.2% |
| N | 8244 | 4.7% |
| P | 7884 | 4.5% |
| L | 7524 | 4.3% |
| G | 6804 | 3.8% |
| Other values (25) | 51804 |
sku_size
Real number (ℝ)
| Distinct | 67 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 461.47051 |
| Minimum | 1 |
|---|---|
| Maximum | 10000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 219.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 90 |
| median | 220 |
| Q3 | 450 |
| 95-th percentile | 1012.5 |
| Maximum | 10000 |
| Range | 9999 |
| Interquartile range (IQR) | 360 |
Descriptive statistics
| Standard deviation | 900.09515 |
|---|---|
| Coefficient of variation (CV) | 1.9504933 |
| Kurtosis | 40.441557 |
| Mean | 461.47051 |
| Median Absolute Deviation (MAD) | 170 |
| Skewness | 5.5003224 |
| Sum | 12958092 |
| Variance | 810171.27 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 200 | 2160 | 7.7% |
| 400 | 1944 | 6.9% |
| 50 | 1728 | 6.2% |
| 90 | 1656 | 5.9% |
| 350 | 1260 | 4.5% |
| 10 | 1152 | 4.1% |
| 750 | 1116 | 4.0% |
| 500 | 1008 | 3.6% |
| 100 | 1008 | 3.6% |
| 250 | 900 | 3.2% |
| Other values (57) | 14148 |
| Value | Count | Frequency (%) |
| 1 | 288 | 1.0% |
| 2 | 288 | 1.0% |
| 3 | 36 | 0.1% |
| 4 | 288 | 1.0% |
| 5 | 540 | |
| 6 | 144 | 0.5% |
| 8 | 216 | 0.8% |
| 10 | 1152 | |
| 12 | 252 | 0.9% |
| 15 | 252 | 0.9% |
| Value | Count | Frequency (%) |
| 10000 | 72 | 0.3% |
| 5000 | 396 | |
| 4000 | 36 | 0.1% |
| 3000 | 720 | |
| 2000 | 72 | 0.3% |
| 1400 | 72 | 0.3% |
| 1250 | 36 | 0.1% |
| 1000 | 468 | |
| 950 | 108 | 0.4% |
| 930 | 504 |
descripcion
Text
| Distinct | 427 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 219.5 KiB |
Length
| Max length | 36 |
|---|---|
| Median length | 27 |
| Mean length | 11.774359 |
| Min length | 2 |
Characters and Unicode
| Total characters | 330624 |
|---|---|
| Distinct characters | 67 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | genoma |
|---|---|
| 2nd row | genoma |
| 3rd row | genoma |
| 4th row | genoma |
| 5th row | genoma |
| Value | Count | Frequency (%) |
| sabor | 3384 | 6.3% |
| 1 | 1476 | 2.7% |
| sopa | 1080 | 2.0% |
| 2 | 1044 | 1.9% |
| 3 | 864 | 1.6% |
| aroma | 864 | 1.6% |
| antibacterial | 792 | 1.5% |
| crema | 792 | 1.5% |
| maquina | 720 | 1.3% |
| regular | 720 | 1.3% |
| Other values (362) | 42084 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 39420 | 11.9% |
| o | 27720 | 8.4% |
| 25776 | 7.8% | |
| i | 24840 | 7.5% |
| e | 21816 | 6.6% |
| r | 20844 | 6.3% |
| n | 19044 | 5.8% |
| l | 15480 | 4.7% |
| t | 13500 | 4.1% |
| s | 12924 | 3.9% |
| Other values (57) | 109260 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 330624 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 39420 | 11.9% |
| o | 27720 | 8.4% |
| 25776 | 7.8% | |
| i | 24840 | 7.5% |
| e | 21816 | 6.6% |
| r | 20844 | 6.3% |
| n | 19044 | 5.8% |
| l | 15480 | 4.7% |
| t | 13500 | 4.1% |
| s | 12924 | 3.9% |
| Other values (57) | 109260 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 330624 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 39420 | 11.9% |
| o | 27720 | 8.4% |
| 25776 | 7.8% | |
| i | 24840 | 7.5% |
| e | 21816 | 6.6% |
| r | 20844 | 6.3% |
| n | 19044 | 5.8% |
| l | 15480 | 4.7% |
| t | 13500 | 4.1% |
| s | 12924 | 3.9% |
| Other values (57) | 109260 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 330624 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 39420 | 11.9% |
| o | 27720 | 8.4% |
| 25776 | 7.8% | |
| i | 24840 | 7.5% |
| e | 21816 | 6.6% |
| r | 20844 | 6.3% |
| n | 19044 | 5.8% |
| l | 15480 | 4.7% |
| t | 13500 | 4.1% |
| s | 12924 | 3.9% |
| Other values (57) | 109260 |
| product_id | periodo | plan_precios_cuidados | cust_request_qty | cust_request_tn | tn | cant_periodos | cat1 | cat2 | cat3 | brand | sku_size | descripcion | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 20001 | 2017-01-01 | 0.0 | 479.0 | 937.72717 | 934.77222 | 36 | HC | ROPA LAVADO | Liquido | ARIEL | 3000 | genoma |
| 1 | 20001 | 2017-02-01 | 0.0 | 432.0 | 833.72187 | 798.01620 | 36 | HC | ROPA LAVADO | Liquido | ARIEL | 3000 | genoma |
| 2 | 20001 | 2017-03-01 | 0.0 | 509.0 | 1330.74697 | 1303.35771 | 36 | HC | ROPA LAVADO | Liquido | ARIEL | 3000 | genoma |
| 3 | 20001 | 2017-04-01 | 0.0 | 279.0 | 1132.94430 | 1069.96130 | 36 | HC | ROPA LAVADO | Liquido | ARIEL | 3000 | genoma |
| 4 | 20001 | 2017-05-01 | 0.0 | 701.0 | 1550.68936 | 1502.20132 | 36 | HC | ROPA LAVADO | Liquido | ARIEL | 3000 | genoma |
| 5 | 20001 | 2017-06-01 | 0.0 | 570.0 | 1575.82891 | 1520.06539 | 36 | HC | ROPA LAVADO | Liquido | ARIEL | 3000 | genoma |
| 6 | 20001 | 2017-07-01 | 0.0 | 381.0 | 1086.47101 | 1030.67391 | 36 | HC | ROPA LAVADO | Liquido | ARIEL | 3000 | genoma |
| 7 | 20001 | 2017-08-01 | 0.0 | 643.0 | 1289.66869 | 1267.39462 | 36 | HC | ROPA LAVADO | Liquido | ARIEL | 3000 | genoma |
| 8 | 20001 | 2017-09-01 | 0.0 | 381.0 | 1356.96103 | 1316.94604 | 36 | HC | ROPA LAVADO | Liquido | ARIEL | 3000 | genoma |
| 9 | 20001 | 2017-10-01 | 0.0 | 273.0 | 1441.60247 | 1439.75563 | 36 | HC | ROPA LAVADO | Liquido | ARIEL | 3000 | genoma |
| product_id | periodo | plan_precios_cuidados | cust_request_qty | cust_request_tn | tn | cant_periodos | cat1 | cat2 | cat3 | brand | sku_size | descripcion | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28070 | 21214 | 2019-03-01 | 0.0 | 0.0 | 0.00000 | 0.00000 | 4 | PC | DEOS | RollOn | NIVEA | 50 | Aroma 14 |
| 28071 | 21214 | 2019-04-01 | 0.0 | 0.0 | 0.00000 | 0.00000 | 4 | PC | DEOS | RollOn | NIVEA | 50 | Aroma 14 |
| 28072 | 21214 | 2019-05-01 | 0.0 | 0.0 | 0.00000 | 0.00000 | 4 | PC | DEOS | RollOn | NIVEA | 50 | Aroma 14 |
| 28073 | 21214 | 2019-06-01 | 0.0 | 0.0 | 0.00000 | 0.00000 | 4 | PC | DEOS | RollOn | NIVEA | 50 | Aroma 14 |
| 28074 | 21214 | 2019-07-01 | 0.0 | 0.0 | 0.00000 | 0.00000 | 4 | PC | DEOS | RollOn | NIVEA | 50 | Aroma 14 |
| 28075 | 21214 | 2019-08-01 | 0.0 | 0.0 | 0.00000 | 0.00000 | 4 | PC | DEOS | RollOn | NIVEA | 50 | Aroma 14 |
| 28076 | 21214 | 2019-09-01 | 0.0 | 3.0 | 0.34250 | 0.34250 | 4 | PC | DEOS | RollOn | NIVEA | 50 | Aroma 14 |
| 28077 | 21214 | 2019-10-01 | 0.0 | 46.0 | 0.21735 | 0.21735 | 4 | PC | DEOS | RollOn | NIVEA | 50 | Aroma 14 |
| 28078 | 21214 | 2019-11-01 | 0.0 | 88.0 | 0.84012 | 0.84012 | 4 | PC | DEOS | RollOn | NIVEA | 50 | Aroma 14 |
| 28079 | 21214 | 2019-12-01 | 0.0 | 55.0 | 0.24428 | 0.24428 | 4 | PC | DEOS | RollOn | NIVEA | 50 | Aroma 14 |